﻿CREATE TABLE [dbo].[ProductInfo] (
    [Id]                   INT             IDENTITY (1, 1) NOT NULL,
    [ProductCode]          NVARCHAR (50)   CONSTRAINT [DF_ProductInfo_ProductCode] DEFAULT (('{'+CONVERT([char](36),newid(),0))+'}') NOT NULL,
    [ProductName]          NVARCHAR (200)  NOT NULL,
    [ProductModel]         NVARCHAR (50)   NULL,
    [ProductStandard]      NVARCHAR (50)   NULL,
    [ProductCategory]      NVARCHAR (50)   NULL,
    [ProductUnit]          NVARCHAR (20)   NULL,
    [ProductDescription]   NVARCHAR (1000) NULL,
    [MiddleRate]           DECIMAL (19, 4) NULL,
    [ReferenceCoefficient] DECIMAL (19, 4) NULL,
    [ProductPrice]         DECIMAL (19, 4) NULL,
    [WholesalePrice]       DECIMAL (19, 4) NULL,
    [PromotionPrice]       DECIMAL (19, 4) NULL,
    [InternalPrice]        DECIMAL (19, 4) NULL,
    [SpecialPrice]         DECIMAL (19, 4) NULL,
    [Enabled]              INT             CONSTRAINT [DF__ProductIn__Enabl__68687968] DEFAULT ((0)) NOT NULL,
    [Description]          NVARCHAR (2000) NULL,
    [DeleteMark]           INT             CONSTRAINT [DF__ProductIn__Delet__695C9DA1] DEFAULT ((0)) NOT NULL,
    [CreateOn]             DATETIME        CONSTRAINT [DF__ProductIn__Creat__6A50C1DA] DEFAULT (getdate()) NOT NULL,
    [CreateUserId]         NVARCHAR (50)   NULL,
    [CreateBy]             NVARCHAR (50)   NULL,
    [ModifiedOn]           DATETIME        NULL,
    [ModifyUserId]         NVARCHAR (50)   NULL,
    [ModifiedBy]           NVARCHAR (50)   NULL,
    CONSTRAINT [PK_PRODUCTINFO] PRIMARY KEY CLUSTERED ([Id] ASC)
);

